package cn.com.xf.dao.impl;

import java.util.List;

import org.springframework.stereotype.Repository;

import cn.com.xf.dao.TbchinaareaDAO;
import cn.com.xf.dao.support.XFSqlMapClientDaoSupport;
import cn.com.xf.domain.Tbchinaarea;
import cn.com.xf.domain.TblDestination;

@Repository
public class TbchinaareaDAOImpl extends XFSqlMapClientDaoSupport implements TbchinaareaDAO {
	@Override
	public Tbchinaarea selectCityNameByAreaId(String areaId) {
		return (Tbchinaarea)getSqlMapClientTemplate().queryForObject("TBCHINAAREA.selectCityNameByAreaId",areaId);
	}

	public List<Tbchinaarea> getProv() {
		return getSqlMapClientTemplate().queryForList("TBCHINAAREA.getProv");
	}

	@Override
	public List<Tbchinaarea> ProvAndCity(String prov) {
		List<Tbchinaarea> list = getSqlMapClientTemplate().queryForList("TBCHINAAREA.selectProvAndCity",prov);	
		return list;
	}

	@Override
	public List<Tbchinaarea> CityAndArea(String city) {
		List<Tbchinaarea> list = getSqlMapClientTemplate().queryForList("TBCHINAAREA.selectCityAndArea",city);	
		return list;
	}

}
